<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-5-26. 8:14:36-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Potential Resource Contention - NetApp Volumes</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Volumes with Highest Deviation from averages</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Bullies and Victims)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Master">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat><CSS value="font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Latency (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-weight:bold"/><dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Latency (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Deviation"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat><CSS value="font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Deviation"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Deviation"><listFooter><listRows><listRow><rowCells><rowCell colSpan="6"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List2" refQuery="Client">
			
			
			
			
			<style>
				<CSS value="border-collapse:collapse;border:1pt solid white"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="background-color:white;text-align:left;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;width:500px;word-wrap:break-word;word-break:break-all;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="background-color:white;font-weight:bold;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border:1pt solid white"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="background-color:white;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Latency (ms)"/></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border:1pt solid white"/><dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Latency (ms)"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="background-color:white;font-weight:bold;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Deviation"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border:1pt solid white"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Deviation"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="background-color:white;font-weight:bold;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Percentile"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;border:1pt solid white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Percentile"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="Pool Name"/></masterContext><detailContext><dataItemContext refDataItem="Pool Name"/></detailContext></masterDetailLink></masterDetailLinks><listPageHeader><listRows><listRow><rowCells><rowCell colSpan="5"><contents><textItem><dataSource><staticValue>Potential Victims - Volumes with highest latency deviation relative to IOpS.  </staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="lh"/></defaultStyles><CSS value="color:gray;font-weight:bold"/></style></rowCell></rowCells></listRow></listRows></listPageHeader><noDataHandler><contents><block><contents><textItem><dataSource><staticValue>No correlated volumes can be found that match the criteria</staticValue></dataSource></textItem></contents></block></contents></noDataHandler></list></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:white;text-align:left;padding-top:10px;padding-bottom:25px"/></style></rowCell></rowCells></listRow></listRows></listFooter><sortList><sortItem refDataItem="Deviation" sortOrder="descending"/></sortList></listGroup></listGroups><listPageHeader><listRows><listRow><rowCells><rowCell colSpan="6"><contents><textItem><dataSource><staticValue>Potential Bully - Volume with highest IOpS deviation in Pool</staticValue></dataSource><style><CSS value="font-size:8pt;color:gray;font-weight:bold"/></style></textItem></contents><style><defaultStyles><defaultStyle refStyle="lh"/></defaultStyles></style></rowCell></rowCells></listRow></listRows></listPageHeader></list></contents><style><CSS value="padding:5px;height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>3.17 Potential Resource Contention - NetApp Volumes</reportName><queries><query name="Master">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.storage_pool_dimension.name as 'Pool Name',
dwh_performance.internal_volume_dimension.name as 'Volume',
dwh_performance.internal_volume_hourly_performance_fact.totalresponsetimemax as 'Peak Latency (ms)',
dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax as 'Peak IOpS',
dwh_performance.date_dimension.fulldate as 'Full Date'

FROM 	dwh_performance.internal_volume_hourly_performance_fact
JOIN  	dwh_performance.storage_dimension
ON   	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagetk
JOIN 	dwh_performance.storage_pool_dimension
ON   	dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagepooltk
JOIN 	dwh_performance.internal_volume_dimension
ON   	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.internalvolumetk
JOIN  	dwh_performance.date_dimension
ON   	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.datetk


WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_hourly_performance_fact ON dwh_performance.internal_volume_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP by dwh_performance.internal_volume_dimension.name, dwh_performance.storage_dimension.name, dwh_performance.storage_pool_dimension.name, dwh_performance.date_dimension.tk

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem label="Bully" name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem aggregate="maximum" name="Peak Latency (ms)"><expression>[SQL1].[Peak Latency (ms)]</expression></dataItem><dataItem aggregate="maximum" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem label="IOpS Deviation" name="Deviation"><expression>standard-deviation ([Peak IOpS])</expression></dataItem><dataItem name="Percentile"><expression>percentile ([Deviation])</expression></dataItem><dataItem name="rank"><expression>rank([Deviation])</expression></dataItem></selection>
		</query><query name="Client">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.storage_pool_dimension.name as 'Pool Name',
dwh_performance.internal_volume_dimension.name as 'Volume',
dwh_performance.internal_volume_hourly_performance_fact.totalresponsetimemax as 'Peak Latency (ms)',
dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax as 'Peak IOpS',
dwh_performance.date_dimension.fulldate as 'Full Date'

FROM 	dwh_performance.internal_volume_hourly_performance_fact
JOIN  	dwh_performance.storage_dimension
ON   	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagetk
JOIN 	dwh_performance.storage_pool_dimension
ON   	dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagepooltk
JOIN 	dwh_performance.internal_volume_dimension
ON   	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.internalvolumetk
JOIN  	dwh_performance.date_dimension
ON   	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.datetk


WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_hourly_performance_fact ON dwh_performance.internal_volume_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP by dwh_performance.internal_volume_dimension.name, dwh_performance.storage_dimension.name, dwh_performance.storage_pool_dimension.name, dwh_performance.date_dimension.tk

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem label="Volume" name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem aggregate="maximum" name="Peak Latency (ms)"><expression>[SQL1].[Peak Latency (ms)]</expression></dataItem><dataItem aggregate="maximum" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem label="Latency Deviation" name="Deviation"><expression>if(standard-deviation ([Peak Latency (ms)]) is null) THEN (0) ELSE (standard-deviation ([Peak Latency (ms)]))</expression></dataItem><dataItem name="Percentile"><expression>percentile ([Deviation])</expression></dataItem><dataItem name="rank"><expression>rank([Deviation])</expression></dataItem><dataItem name="Total Peak IOpS"><expression>total([Peak IOpS] for [Volume])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Peak Latency (ms)]&gt;0</filterExpression></detailFilter><detailFilter><filterExpression>[Total Peak IOpS]&lt;1000</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters><summaryFilters><summaryFilter><filterExpression>[Deviation]&gt;=1</filterExpression></summaryFilter></summaryFilters></query><query name="Top Victims">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
dwh_performance.internal_volume_dimension.name as 'Volume',
dwh_performance.internal_volume_hourly_performance_fact.totalresponsetimemax as 'Peak Latency (ms)',
dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax as 'Peak IOpS'

FROM 	dwh_performance.internal_volume_hourly_performance_fact
JOIN  	dwh_performance.storage_dimension
ON   	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagetk
JOIN 	dwh_performance.storage_pool_dimension
ON   	dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagepooltk
JOIN 	dwh_performance.internal_volume_dimension
ON   	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.internalvolumetk
JOIN  	dwh_performance.date_dimension
ON   	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.datetk


WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_hourly_performance_fact ON dwh_performance.internal_volume_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP by dwh_performance.internal_volume_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Peak IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem label="Volume Victim" name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem aggregate="maximum" name="Peak Latency (ms)"><expression>[SQL1].[Peak Latency (ms)]</expression></dataItem><dataItem aggregate="maximum" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem aggregate="maximum" name="Deviation"><expression>standard-deviation ([Peak Latency (ms)])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Peak Latency (ms)]&gt;0</filterExpression></detailFilter></detailFilters></query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:maroon;font-weight:bold"/></style><reportCondition>[Client].[Percentile]&gt;=.75</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles></report>